123456/PO PHP H5/Julian - Felix/moordenaars.php

<!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" href="style/style.css"> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <html><h1>moordenaars</h1></html> </head> <body> <table border="1"> <tr> <th>Moordenaar ID</th> <th>Gevangenis ID</th> <th>Moord ID</th> <th>Voornaam</th> <th>Tweedenaam</th> <th>Tussenvoegsel</th> <th>Achternaam</th> <th>Status</th> <th>Woonplaats</th> <th>Geboortedatum</th> </tr> <?php include('db.php'); $query = "select * from moordenaar"; $result = mysqli_query($db, $query); while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td><a href='moordenaars_gegevens.php?moordenaarID=" . $row['moordenaarID'] . "'>" . $row['moordenaarID'] . "</a></td>"; echo "<td><a href='gevangenis_gegevens.php?gevangenisID=" . $row['gevangenisID'] . "'>" . $row['gevangenisID'] . "</a></td>"; echo "<td><a href='moorden.php?MoordID=" . $row['MoordID'] . "'>" . $row['MoordID'] . "</td>"; echo "<td><a href='moordenaars_gegevens.php?moordenaarID=" . $row['moordenaarID'] . "'>" . $row['voornaam'] . "</a></td>"; echo "<td><a href='moordenaars_gegevens.php?moordenaarID=" . $row['moordenaarID'] . "'>" . $row['tweedeNaam'] . "</a></td>"; echo "<td>" . $row['tussenvoegsel'] . "</td>"; echo "<td><a href='moordenaars_gegevens.php?moordenaarID=" . $row['moordenaarID'] . "'>" . $row['achternaam'] . "</a></td>"; echo "<td>" . $row['status'] . "</a></td>"; echo "<td>" . $row['woon_plaats'] . "</td>"; echo "<td>" . $row['geb_datum'] . "</td>"; echo "</tr>"; } ?> <button onclick="location.href='gevangenis.php'">gevangenissen</button> <button onclick="location.href='moorden.php'">moorden</button> <button onclick="location.href='slachtoffers.php'">slachtoffers</button> <button onclick="location.href='index.php'">homepagina</button> </table> </body> </html>

Resultaat

Made by Thijs Aarnoudse